ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study
نویسندگان
چکیده
منابع مشابه
A Conceptual Modeling Approach for Data Warehouses
The multidimensional (MD) modeling, which is the foundation of data warehouses (DWs), MD databases, and On-Line Analytical Processing (OLAP) applications, is based on several properties different from those in traditional database modeling. In the past few years, there have been some proposals, providing their own formal and graphical notations, for representing the main MD properties at the co...
متن کاملQuery Optimizer for the ETL Process in Data Warehouses
ETL (Extraction-Transformation-Loading) process is responsible for extracting data from several sources, cleansing, transforming, integrating and loading into a data warehouse. Extraction process accesses large amount of data by executing several complex queries in source databases. These queries are repetitive and executed at regular interval to refresh the data warehouse. Extraction of data f...
متن کاملMultidimensional Design Paradigms for Data Warehouses: A Systematic Mapping Study
Data warehouses (DW) must integrate information from the different areas and sources of an organization in order to extract knowledge relevant to decision-making. The DW development is not an easy task, which is why various design approaches have been put forward. These approaches can be classified in three different paradigms according to the origin of the information requirements: supply-driv...
متن کاملNew Conceptual Modeling Requirements for Stream Data Warehouses (C)
OLAP and Data Warehouse (DW) systems are decision support technologies allowing users to explore and analyze huge volume of data. Benefits of conceptual modeling of DW have been widely recognized in several works. In this position paper we address stream data (i.e. real real-time continuous ordered and sequence of items), and we define the requirements of conceptual models for DW integrating st...
متن کاملA UML Based Approach for Modeling ETL Processes in Data Warehouses
Data warehouses (DWs) are complex computer systems whose main goal is to facilitate the decision making process of knowledge workers. ETL (Extraction-Transformation-Loading) processes are responsible for the extraction of data from heterogeneous operational data sources, their transformation (conversion, cleaning, normalization, etc.) and their loading into DWs. ETL processes are a key componen...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: IEEE Latin America Transactions
سال: 2011
ISSN: 1548-0992
DOI: 10.1109/tla.2011.5893784